SELECT T.* FROM C1_DICTIONARY T WHERE t.type_name like :typeName AND t.name like :name
order by t.ORDER_NUM
